<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>广东信令数据效验</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<script type="text/javascript" src="js/jquery/jquery-1.9.1.min.js"></script>
	<script type="text/javascript">
	  $(document).ready(function(){
		  $("#search").click(function(){
		  	 var tbName = $("#tabName").val();
		  	 if(tbName == ''){
		  	 	return false;
		  	 }
		  	 
		  	 // 提交表单
		  	 $("#fm1").submit();
		  });
	  });

	  
	</script>
  </head>
  
  <body>
    <form action="query.action" id="fm1">
    	<table cellpadding="1" cellspacing="1" width="100%">
    	<br/>
  			<tr >
  				<td colspan="3" width="80%">
    			表名：	<input type="text" id="tabName" name="tableName" value="${tableName}" size="70"/>&nbsp;
    					<input type="hidden" name="Sql" value="${Sql}" />
    					<input type="button" id="search" value="查询">
    			</td>
  			</tr>
  			<tr>
  				<td colspan="3">&nbsp;</td>
  			</tr>
  			<tr>
  				<td colspan="3">ETL汇聚（15M:H:D）[ ${etl_tab_count}]</td>
  			</tr>
  			
  			<tr>
  				<td colspan="3">&nbsp;</td>
  			</tr>
  			
  			<tr>
  				<td colspan="3">错误话单表（条数：I表：F表：汇聚表）[ ${errer_list}]</td>
  			</tr>
  			
			<tr>
  				<td colspan="3">&nbsp;</td>
  			</tr>
  			
  			<tr>
  				<td colspan="1" width="15%">查询SQL</td>
  				<td colspan="2">
  					<!-- 
  					<textarea rows="3" cols="80" style="white-space:nowrap; overflow-x:scroll; overflow-y:hidden;">${sql}</textarea>
  					 -->
  					<div id="dv1">${sql}</div>
  				</td>
  			</tr>
  			<tr>
  				<td colspan="1" width="15%">求和SQL</td>
  				<td colspan="2">
  					<!-- 
  					<textarea rows="3" cols="80" style="white-space:nowrap; overflow-x:scroll; overflow-y:hidden;">${sql}</textarea>
  					 -->
  					<div id="dv2">${sumSql}</div>
  				</td>
  			</tr>
  			
    		<tr>
    			<td>表名</td>
    			<td>序号</td>
    			<td>列名</td>
    			<td><input type="checkbox" name="checkAll" id="checkAll"/>全选</td>
    		</tr>
    		<!-- 
    		<s:iterator id="obj" value="list" status="st">
    			<tr>
    				<td>${tableName}</td>
    				<td><s:property value="#st.index"/></td>
    				<td><s:property value="#obj.columnName"/></td>
    				<td><input type="checkbox" name="" value="<s:property value="#st.index"/>" id="<s:property value="#st.index"/>"/></td>
    			</tr>
    		</s:iterator>
    		 -->
    		
    	</table>
    	
    </form>
  </body>
</html>
